Ancestry Product Analytics Homework Assignment

Initial Look at Data

Dataset

Data Summary

Categorical Variables in Bar Charts

Numeric Variables in Histograms

Time Series Variables

Outliers and Notes

• ID variables
  • 33,407 prospectids appear multiple times, accounting for 85,349 rows in the dataset
• Categorical variables
  • dna_visittrafficsubtype has roughly 15 non-NA subtypes over 2000, meaning many subtypes contain very few (for some it’s almost no) observations in this dataset
  • Treating xsell_gsa as categorical.
• Numeric variables
  • xsell_day_exact appears to have a funky distribution, quite log looking. However, the histogram does ignore any zero values, which is roughly 33.8% of the values for that variable. May want to look at a cummulative view of some kind.
• Time series variables
  • ordercreatedate has a date of 1900-01-01 repeated 12 times in the dataset. (Suggest removing these from the dataset.)
  • dnatestactivationdayid has 29% of the values as NA.

Categorial Variable Notes

A closer look at dna_visittrafficsubtype shows that many of the subtypes are rarely found in this dataset.

Time Series Variables (improved)

After removing the outlier dates (noted above) for ordercreatedate we can better see the general trend.

After removing the NAs from dnatestactivationdayid we can better see the general trend.

Cross-sell Percentage

Daily Trend

Variance appears to tighten up in 2016-2017 and the obvious drop in late 2016 to 2017 will cause problems for most models. Forecasting or predicting could prove difficult if the model isn’t able to account for those two behaviors.

A more detailed view of this daily xsell conversion may help us understand what is influencing this behavior and how that might affect model construction.

I must not understand the regtenure column